/*
 Navicat Premium Dump SQL

 Source Server         : 39.96.195.134 - 172.17.32.201
 Source Server Type    : MySQL
 Source Server Version : 50738 (5.7.38-log)
 Source Host           : 39.96.195.134:3306
 Source Schema         : yanjicheng

 Target Server Type    : MySQL
 Target Server Version : 50738 (5.7.38-log)
 File Encoding         : 65001

 Date: 26/11/2024 11:09:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_apis
-- ----------------------------
DROP TABLE IF EXISTS `sys_apis`;
CREATE TABLE `sys_apis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `path` varchar(191) DEFAULT NULL COMMENT 'api路径',
  `description` varchar(191) DEFAULT NULL COMMENT 'api中文描述',
  `api_group` varchar(191) DEFAULT NULL COMMENT 'api组',
  `method` varchar(191) DEFAULT 'POST' COMMENT '方法',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除状态 0 未删除 1 已删除',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_apis
-- ----------------------------
BEGIN;
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (1, '/api/superAdmin/menu/getMenu', '菜单树', '菜单管理', 'GET', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (2, '/api/superAdmin/menu/getMenuList', '菜单列表', '菜单管理', 'GET', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (3, '/api/superAdmin/menu/getMenuById', '根据id获取菜单', '菜单管理', 'GET', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (4, '/api/superAdmin/menu/updateMenu', '更新菜单', '菜单管理', 'POST', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (5, '/api/superAdmin/menu/addMenu', '添加菜单', '菜单管理', 'POST', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (6, '/api/superAdmin/authority/authorityList', '角色列表', '角色管理', 'GET', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (7, '/api/superAdmin/authority/createAuthority', '创建角色', '角色管理', 'POST', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (8, '/api/superAdmin/authority/updateAuthority', '更新角色', '角色管理', 'POST', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (9, '/api/superAdmin/authority/deleteAuthority', '删除角色', '角色管理', 'POST', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (10, '/api/superAdmin/api/allApiList', '获取所有API列表', '接口管理', 'GET', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (11, '/api/superAdmin/menu/getMenusByAuthorityId', '根据角色id获取menu', '接口管理', 'GET', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (12, '/api/superAdmin/api/getApiList', '所有API列表', '接口管理', 'GET', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (13, '/api/superAdmin/api/detail', 'API详情', '接口管理', 'GET', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (14, '/api/superAdmin/api/getPolicyPathByAuthorityId', '根据角色id获取权限', '接口管理', 'GET', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (15, '/api/superAdmin/menu/addMenuAuthority', '添加角色菜单', '接口管理', 'POST', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (16, '/api/superAdmin/api/updateCasbin', '更新角色API', '接口管理', 'POST', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (17, '/api/superAdmin/api/createApi', '创建API', '接口管理', 'POST', 0, '2024-11-20 10:48:51', '2024-11-20 10:48:51');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (18, '/api/superAdmin/api/deleteApi', '删除API', '接口管理', 'POST', 0, '2024-11-20 10:48:52', '2024-11-20 10:48:52');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (19, '/api/superAdmin/api/updateApi', '更新API', '接口管理', 'POST', 0, '2024-11-20 10:48:52', '2024-11-20 10:48:52');
INSERT INTO `sys_apis` (`id`, `path`, `description`, `api_group`, `method`, `deleted`, `created_at`, `updated_at`) VALUES (20, '/api/superAdmin/api/deleteApisByIds', '批量删除', '接口管理', 'POST', 0, '2024-11-20 10:48:52', '2024-11-20 10:48:52');
COMMIT;

-- ----------------------------
-- Table structure for sys_authorities
-- ----------------------------
DROP TABLE IF EXISTS `sys_authorities`;
CREATE TABLE `sys_authorities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `parent_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父角色ID',
  `name` varchar(191) NOT NULL DEFAULT '' COMMENT '角色名',
  `default_router` varchar(191) NOT NULL DEFAULT 'dashboard' COMMENT '默认菜单',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除状态 0 未删除 1已删除',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `authority_id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_authorities
-- ----------------------------
BEGIN;
INSERT INTO `sys_authorities` (`id`, `parent_id`, `name`, `default_router`, `deleted`, `created_at`, `updated_at`) VALUES (1, 0, '超级管理员', 'dashboard', 0, '2024-11-20 10:49:44', '2024-11-20 10:49:44');
COMMIT;

-- ----------------------------
-- Table structure for sys_authority_apis
-- ----------------------------
DROP TABLE IF EXISTS `sys_authority_apis`;
CREATE TABLE `sys_authority_apis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `authority_id` bigint(20) NOT NULL COMMENT '角色id',
  `path` varchar(128) NOT NULL DEFAULT '' COMMENT 'API地址',
  `method` varchar(32) NOT NULL DEFAULT '' COMMENT '请求方式',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除状态 0 未删除 1 已删除',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_authority_apis` (`authority_id`,`path`,`method`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_authority_apis
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_authority_buttons
-- ----------------------------
DROP TABLE IF EXISTS `sys_authority_buttons`;
CREATE TABLE `sys_authority_buttons` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `authority_id` bigint(20) unsigned NOT NULL COMMENT '角色ID',
  `menu_id` bigint(20) unsigned NOT NULL COMMENT '菜单ID',
  `menu_button_id` bigint(20) unsigned NOT NULL COMMENT '菜单按钮ID',
  `deleted` tinyint(1) NOT NULL COMMENT '删除状态 0 未删除 1 已删除',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_authority_buttons
-- ----------------------------
BEGIN;
INSERT INTO `sys_authority_buttons` (`id`, `authority_id`, `menu_id`, `menu_button_id`, `deleted`, `created_at`, `updated_at`) VALUES (1, 888, 7, 2, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `sys_authority_buttons` (`id`, `authority_id`, `menu_id`, `menu_button_id`, `deleted`, `created_at`, `updated_at`) VALUES (2, 888, 32, 1, 1, '0000-00-00 00:00:00', '2024-11-06 12:55:53');
INSERT INTO `sys_authority_buttons` (`id`, `authority_id`, `menu_id`, `menu_button_id`, `deleted`, `created_at`, `updated_at`) VALUES (3, 888, 32, 3, 1, '0000-00-00 00:00:00', '2024-11-06 12:55:53');
COMMIT;

-- ----------------------------
-- Table structure for sys_authority_menus
-- ----------------------------
DROP TABLE IF EXISTS `sys_authority_menus`;
CREATE TABLE `sys_authority_menus` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `menu_id` bigint(20) unsigned NOT NULL COMMENT '菜单id',
  `authority_id` bigint(20) unsigned NOT NULL COMMENT '角色ID',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除状态 0 未删除 1 已删除',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_authority_menus
-- ----------------------------
BEGIN;
INSERT INTO `sys_authority_menus` (`id`, `menu_id`, `authority_id`, `deleted`, `created_at`, `updated_at`) VALUES (1, 1, 1, 0, '2024-11-20 10:50:20', '2024-11-20 10:50:20');
INSERT INTO `sys_authority_menus` (`id`, `menu_id`, `authority_id`, `deleted`, `created_at`, `updated_at`) VALUES (2, 2, 1, 0, '2024-11-20 10:50:20', '2024-11-20 10:50:20');
INSERT INTO `sys_authority_menus` (`id`, `menu_id`, `authority_id`, `deleted`, `created_at`, `updated_at`) VALUES (3, 3, 1, 0, '2024-11-20 10:50:20', '2024-11-20 10:50:20');
INSERT INTO `sys_authority_menus` (`id`, `menu_id`, `authority_id`, `deleted`, `created_at`, `updated_at`) VALUES (4, 4, 1, 0, '2024-11-20 10:50:20', '2024-11-20 10:50:20');
INSERT INTO `sys_authority_menus` (`id`, `menu_id`, `authority_id`, `deleted`, `created_at`, `updated_at`) VALUES (5, 5, 1, 0, '2024-11-20 10:50:20', '2024-11-20 10:50:20');
INSERT INTO `sys_authority_menus` (`id`, `menu_id`, `authority_id`, `deleted`, `created_at`, `updated_at`) VALUES (6, 6, 1, 1, '2024-11-20 10:50:20', '2024-11-20 03:04:08');
INSERT INTO `sys_authority_menus` (`id`, `menu_id`, `authority_id`, `deleted`, `created_at`, `updated_at`) VALUES (7, 7, 1, 0, '2024-11-20 04:01:59', '2024-11-20 04:01:59');
INSERT INTO `sys_authority_menus` (`id`, `menu_id`, `authority_id`, `deleted`, `created_at`, `updated_at`) VALUES (8, 8, 1, 0, '2024-11-20 04:01:59', '2024-11-20 04:01:59');
INSERT INTO `sys_authority_menus` (`id`, `menu_id`, `authority_id`, `deleted`, `created_at`, `updated_at`) VALUES (9, 9, 1, 0, '2024-11-21 08:08:30', '2024-11-21 08:08:30');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu_buttons
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu_buttons`;
CREATE TABLE `sys_menu_buttons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL DEFAULT '' COMMENT '按钮关键key',
  `desc` varchar(191) NOT NULL DEFAULT '' COMMENT '简介',
  `menu_id` bigint(20) unsigned NOT NULL COMMENT '菜单ID',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除状态 0 未删除 1 已删除',
  `created_at` datetime(3) NOT NULL COMMENT '创建时间',
  `updated_at` datetime(3) NOT NULL ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_menu_buttons
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu_buttons` (`id`, `name`, `desc`, `menu_id`, `deleted`, `created_at`, `updated_at`) VALUES (1, 'test', 'test', 32, 1, '2024-06-09 16:46:52.721', '2024-11-06 12:55:53.000');
INSERT INTO `sys_menu_buttons` (`id`, `name`, `desc`, `menu_id`, `deleted`, `created_at`, `updated_at`) VALUES (2, 'test', 'test', 7, 0, '2024-06-09 16:48:03.063', '2024-06-09 16:48:03.063');
INSERT INTO `sys_menu_buttons` (`id`, `name`, `desc`, `menu_id`, `deleted`, `created_at`, `updated_at`) VALUES (3, 'test2', 'test2222', 32, 1, '2024-06-10 22:31:21.359', '2024-11-06 12:55:53.000');
INSERT INTO `sys_menu_buttons` (`id`, `name`, `desc`, `menu_id`, `deleted`, `created_at`, `updated_at`) VALUES (5, 'test-01-1', 'test-01-1', 72, 0, '2024-06-11 22:48:02.952', '2024-06-11 22:48:02.952');
INSERT INTO `sys_menu_buttons` (`id`, `name`, `desc`, `menu_id`, `deleted`, `created_at`, `updated_at`) VALUES (6, 'test-01-2', 'test-01-2', 72, 0, '2024-06-11 22:48:02.952', '2024-06-11 22:48:02.952');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu_parameters
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu_parameters`;
CREATE TABLE `sys_menu_parameters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` bigint(20) unsigned NOT NULL COMMENT '菜单id',
  `type` varchar(191) NOT NULL DEFAULT '' COMMENT '地址栏携带参数为params还是query',
  `key` varchar(191) NOT NULL DEFAULT '' COMMENT '地址栏携带参数的key',
  `value` varchar(191) NOT NULL DEFAULT '' COMMENT '地址栏携带参数的值',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 0 未删除 1 已删除',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_menu_parameters
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menus
-- ----------------------------
DROP TABLE IF EXISTS `sys_menus`;
CREATE TABLE `sys_menus` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `menu_level` bigint(20) unsigned NOT NULL DEFAULT '0',
  `parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '父菜单ID',
  `path` varchar(191) NOT NULL DEFAULT '' COMMENT '路由path',
  `name` varchar(191) NOT NULL DEFAULT '' COMMENT '路由name',
  `hidden` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否在列表隐藏',
  `component` varchar(191) NOT NULL DEFAULT '' COMMENT '对应前端文件路径',
  `sort` bigint(20) NOT NULL DEFAULT '0' COMMENT '排序标记',
  `active_name` varchar(191) NOT NULL DEFAULT '' COMMENT '附加属性',
  `keep_alive` tinyint(1) NOT NULL DEFAULT '0' COMMENT '附加属性',
  `default_menu` tinyint(1) NOT NULL DEFAULT '0' COMMENT '附加属性',
  `title` varchar(191) NOT NULL DEFAULT '' COMMENT '附加属性',
  `icon` varchar(191) NOT NULL DEFAULT '' COMMENT '附加属性',
  `close_tab` tinyint(1) NOT NULL DEFAULT '0' COMMENT '附加属性',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 是',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_menus
-- ----------------------------
BEGIN;
INSERT INTO `sys_menus` (`id`, `menu_level`, `parent_id`, `path`, `name`, `hidden`, `component`, `sort`, `active_name`, `keep_alive`, `default_menu`, `title`, `icon`, `close_tab`, `deleted`, `created_at`, `updated_at`) VALUES (1, 0, 0, 'dashboard', 'dashboard', 0, 'view/dashboard/index.vue', 0, '', 0, 0, '仪表盘', 'odometer', 0, 0, '2024-11-20 10:03:40', '2024-11-20 10:03:40');
INSERT INTO `sys_menus` (`id`, `menu_level`, `parent_id`, `path`, `name`, `hidden`, `component`, `sort`, `active_name`, `keep_alive`, `default_menu`, `title`, `icon`, `close_tab`, `deleted`, `created_at`, `updated_at`) VALUES (2, 0, 0, 'admin', 'superAdmin', 0, 'view/superAdmin/index.vue', 3, '', 0, 0, '超级管理员', 'user', 0, 0, '2024-11-20 10:03:40', '2024-11-20 10:03:40');
INSERT INTO `sys_menus` (`id`, `menu_level`, `parent_id`, `path`, `name`, `hidden`, `component`, `sort`, `active_name`, `keep_alive`, `default_menu`, `title`, `icon`, `close_tab`, `deleted`, `created_at`, `updated_at`) VALUES (3, 0, 2, 'authority', 'authority', 0, 'view/superAdmin/authority/authority.vue', 1, '', 0, 0, '角色管理', 'avatar', 0, 0, '2024-11-20 10:03:40', '2024-11-20 11:03:43');
INSERT INTO `sys_menus` (`id`, `menu_level`, `parent_id`, `path`, `name`, `hidden`, `component`, `sort`, `active_name`, `keep_alive`, `default_menu`, `title`, `icon`, `close_tab`, `deleted`, `created_at`, `updated_at`) VALUES (4, 0, 2, 'menu', 'menu', 0, 'view/superAdmin/menu/menu.vue', 2, '', 1, 0, '菜单管理', 'tickets', 0, 0, '2024-11-20 10:03:41', '2024-11-20 11:03:43');
INSERT INTO `sys_menus` (`id`, `menu_level`, `parent_id`, `path`, `name`, `hidden`, `component`, `sort`, `active_name`, `keep_alive`, `default_menu`, `title`, `icon`, `close_tab`, `deleted`, `created_at`, `updated_at`) VALUES (5, 0, 2, 'api', 'api', 0, 'view/superAdmin/api/api.vue', 3, '', 1, 0, 'api管理', 'platform', 0, 0, '2024-11-20 10:03:41', '2024-11-20 11:03:43');
INSERT INTO `sys_menus` (`id`, `menu_level`, `parent_id`, `path`, `name`, `hidden`, `component`, `sort`, `active_name`, `keep_alive`, `default_menu`, `title`, `icon`, `close_tab`, `deleted`, `created_at`, `updated_at`) VALUES (6, 0, 2, 'user', 'user', 0, 'view/superAdmin/user/user.vue', 4, '', 0, 0, '用户管理', 'coordinate', 0, 0, '2024-11-20 10:03:41', '2024-11-20 11:03:43');
INSERT INTO `sys_menus` (`id`, `menu_level`, `parent_id`, `path`, `name`, `hidden`, `component`, `sort`, `active_name`, `keep_alive`, `default_menu`, `title`, `icon`, `close_tab`, `deleted`, `created_at`, `updated_at`) VALUES (7, 0, 0, 'collection', 'collection', 0, 'view/routerHolder.vue', 0, '', 0, 0, '藏品管理', 'aim', 0, 0, '2024-11-20 04:01:04', '2024-11-20 04:01:49');
INSERT INTO `sys_menus` (`id`, `menu_level`, `parent_id`, `path`, `name`, `hidden`, `component`, `sort`, `active_name`, `keep_alive`, `default_menu`, `title`, `icon`, `close_tab`, `deleted`, `created_at`, `updated_at`) VALUES (8, 0, 7, 'collectionList', 'collectionList', 0, 'view/collection/index.vue', 0, '', 0, 0, '藏品列表', 'aim', 0, 0, '2024-11-20 04:01:41', '2024-11-21 08:12:06');
INSERT INTO `sys_menus` (`id`, `menu_level`, `parent_id`, `path`, `name`, `hidden`, `component`, `sort`, `active_name`, `keep_alive`, `default_menu`, `title`, `icon`, `close_tab`, `deleted`, `created_at`, `updated_at`) VALUES (9, 0, 7, 'collectionFileList', 'collectionFileList', 1, 'view/collection/collectionFile/index.vue', 0, '', 0, 0, '藏品文件列表', 'aim', 0, 0, '2024-11-21 03:10:42', '2024-11-21 08:12:11');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL DEFAULT '' COMMENT '用户UUID',
  `username` varchar(191) NOT NULL DEFAULT '' COMMENT '用户登录名',
  `password` varchar(191) NOT NULL DEFAULT '' COMMENT '用户登录密码',
  `nickname` varchar(191) NOT NULL DEFAULT '系统用户' COMMENT '用户昵称',
  `side_mode` varchar(191) NOT NULL DEFAULT 'dark' COMMENT '用户侧边主题',
  `header_img` varchar(191) NOT NULL DEFAULT 'https://qmplusimg.henrongyi.top/gva_header.jpg' COMMENT '用户头像',
  `base_color` varchar(191) NOT NULL DEFAULT '#fff' COMMENT '基础颜色',
  `active_color` varchar(191) NOT NULL DEFAULT '#1890ff' COMMENT '活跃颜色',
  `authority_id` bigint(20) unsigned NOT NULL DEFAULT '888' COMMENT '用户角色ID',
  `phone` varchar(191) NOT NULL DEFAULT '' COMMENT '用户手机号',
  `email` varchar(191) NOT NULL DEFAULT '' COMMENT '用户邮箱',
  `enable` bigint(20) NOT NULL DEFAULT '1' COMMENT '用户是否被冻结 1正常 2冻结',
  `introduction` varchar(255) NOT NULL DEFAULT '' COMMENT '个人介绍',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 0 否 1 是',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_sys_users_uuid` (`uuid`),
  KEY `idx_sys_users_username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`id`, `uuid`, `username`, `password`, `nickname`, `side_mode`, `header_img`, `base_color`, `active_color`, `authority_id`, `phone`, `email`, `enable`, `introduction`, `deleted`, `created_at`, `updated_at`) VALUES (1, '1', 'admin', 'a750f04e409493f73af2062f41842289', '系统用户', 'dark', 'https://qmplusimg.henrongyi.top/gva_header.jpg', '#fff', '#1890ff', 1, '', '', 1, '个人介绍', 0, '2024-10-23 10:41:37', '2024-11-20 10:59:20');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
